Exam 77-427 Microsoft Excel 2013 Expert 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use PowerPivot (Filter the Data)

Filter the Data Some database Records go waaaay back in time to the beginning of a company or a project. The old data may be used to create year-over-year comparisons and other historical reports. Sometime, the focus is much more narrow. PowerPivots have Filters as well. Here are the steps to Filter the discontinued Items.   8. Try This: Apply a Filter to a Field Select a Field: Discontinued. Go to Home->Sort and Filter. Select a Filter: False. (True is not selected). Click OK. The Table, tblProducts, has been filtered to show only the current Items-no discontinued ones. Keep going... IImportant to Note: The Data Type for this Field is TRUE/FALSE. Home ->Sort and Filter